/ Assembly List / LJCDBMessage / DbSqlBuilder / KeyWhereClause

Namespace - LJCDBMessage


Returns

The key value where clause.

Syntax

C#
public String KeyWhereClause()

Creates the where clause from the key values.

Remarks

A Key Column is not added to a where clause if its value is null.

A Key Column is not added to a where clause if it is an AutoIncrement column and its value is zero.

If a Key Column is not qualified with a user entered name, then it is qualified with the primary table name

Key Columns where clauses use the "=" comparison operator.

Key Column where clauses comparisons are separated with an "and".

The Key Column where clause will check for "is null" if the value equals "-null" or "-".

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.